#!/usr/bin/env python
#-*- encoding:UTF-8 -*-
"""
Connect to Oracle DB
"""

import unittest
import win32com.client
import adodbapi


# Connect to Oracle;
connStrOC = u"Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ocdb1.grs-cro.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ocp)));User Id=SASEXTRACT;Password=SASEXTRACT;"
connOC = adodbapi.connect(connStrOC)

# Connect to Access;
#mdbfile = ConnAccessDB(r'D:\SMARTER\wxPythonApp\meta_lib.mdb')
#mdbfile = ConnAccessDB(r'D:\wxPythonApp\meta_lib.mdb')
#connStrAccess = u'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=%s' % mdbfile
#connAccess = adodbapi.connect(connStrAccess)


 